------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\sgolder\Dropbox\Portfolio Allocation\replication\ariottigolder-descriptive2.log
  log type:  text
 opened on:  30 Mar 2017, 14:08:57

. set more off

. #delimit ;
delimiter now ;
. *     ***************************************************************** *;
. *     ***************************************************************** *;
. *       File-Name:      ariotti_golder-descriptive2.do                  *;
. *       Date:           September 9, 2016                               *;
. *       Author:         Molly Ariotti and Sona Golder                   *;
. *       Purpose:        Get some descriptive data.                      *;
. *           Input File:     Africa_govt_majority_status.dta                 *;
. *       Output File:    ariottigolder-descriptive2.log                  *;
. *       Data Output:    Africa_govt_descriptive2.dta                    *;
.              *       Previous file:  Africa_govt_majority_status.dta.xls             *;
. *                        --> Stata .dta                                 *;
. *       Machine:        laptop                                                          *;
. *     ****************************************************************  *;
. *     ****************************************************************  *;
. *     ****************************************************************  *;
. *       Open and summarize dataset. Generate some variables.            *;
. *     ****************************************************************  *;
. use "C:\Users\sgolder\Dropbox\Portfolio Allocation\replication\Africa_govt_majority_status.dta";

. *     ****************************************************************  *;
. *       Label variables                                                 *;
. *     ****************************************************************  *;
. label var countryname "country name";

. label var countrycode "country code";

. label var cabinetcode "cabinet code";

. label var cowcode "cow code";

. label var year "year in which government begins";

. label var presidential "1 = presidential, 0 = parliamentary";

.  label var party "party number or acronym";

. label var formateur "1 = formateur, 0 = otherwise";

. label var portfolios "number of portfolios per party";

. label var government_portfolios "number of portfolios in the government";

. label var party_seats "number of legislative seats per party";

. label var government_seats "number of seats controlled by government";

. label var region "1=Africa, 2=Western Europe, 3=Latin America";

. label var leg_size "total number of seats in legislature";

. label var govt_legseatshare "percentage of leg seats controlled by govt";

. sum;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
 countryname |          0
 countrycode |         28    5.714286    2.594255          1          9
 cabinetcode |         28       13.75     7.46163          1         26
     cowcode |         28    515.4643    69.06115        403        590
        year |         28    2002.357    6.870303       1990       2014
-------------+---------------------------------------------------------
presidential |         28    .3928571    .4973475          0          1
       party |          0
   formateur |         28    .9285714    .2622653          0          1
  portfolios |         28    14.39286    6.308955          4         26
governmen~os |         28    21.71429    7.644204          9         45
-------------+---------------------------------------------------------
 party_seats |         28    81.14286    79.97672         24        279
governmen~ts |         28    120.3214    92.45421         39        377
      region |         28           1           0          1          1
    leg_size |         28    162.6786    115.1627         55        400
govt_legse~e |         28    76.79179    19.83417      33.16        100

. desc;

Contains data from C:\Users\sgolder\Dropbox\Portfolio Allocation\replication\Africa_govt_majority_status.dta
  obs:            28                          
 vars:            15                          4 Nov 2016 17:08
 size:         1,428                          
------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
------------------------------------------------------------------------------------------------------------------
countryname     str21   %21s                  country name
countrycode     byte    %8.0g                 country code
cabinetcode     byte    %8.0g                 cabinet code
cowcode         int     %8.0g                 cow code
year            int     %8.0g                 year in which government begins
presidential    byte    %8.0g                 1 = presidential, 0 = parliamentary
party           str9    %9s                   party number or acronym
formateur       byte    %8.0g                 1 = formateur, 0 = otherwise
portfolios      byte    %8.0g                 number of portfolios per party
government_po~s byte    %8.0g                 number of portfolios in the government
party_seats     int     %8.0g                 number of legislative seats per party
government_se~s int     %8.0g                 number of seats controlled by government
region          byte    %8.0g                 1=Africa, 2=Western Europe, 3=Latin America
leg_size        int     %8.0g                 total number of seats in legislature
govt_legseats~e float   %8.0g                 percentage of leg seats controlled by govt
------------------------------------------------------------------------------------------------------------------
Sorted by: 

. *     ****************************************************************  *;
. *      Get some descriptive statistics about govt_legseatshare, with    *;
. *      all cases and then excluding the 2 govts without partisan        *;
. *      formateurs (b/c they are dropped from the analyses in the paper  *;
. *     ****************************************************************  *;
. sum govt_legseatshare;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
govt_legse~e |         28    76.79179    19.83417      33.16        100

. sum govt_legseatshare if presidential==0;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
govt_legse~e |         17    81.73353     13.8864      50.83        100

. sum govt_legseatshare if presidential==1;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
govt_legse~e |         11    69.15455    25.45501      33.16      97.17

. ttest govt_legseatshare, by(presidential) unequal;

Two-sample t test with unequal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
       0 |      17    81.73353    3.367946     13.8864     74.5938    88.87326
       1 |      11    69.15455    7.674973    25.45501    52.05364    86.25545
---------+--------------------------------------------------------------------
combined |      28    76.79179    3.748305    19.83417     69.1009    84.48267
---------+--------------------------------------------------------------------
    diff |            12.57898    8.381424               -5.409528     30.5675
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   1.5008
Ho: diff = 0                     Satterthwaite's degrees of freedom =     13.9

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.9221         Pr(|T| > |t|) = 0.1558          Pr(T > t) = 0.0779

. sum govt_legseatshare if formateur==1;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
govt_legse~e |         26    75.00654    19.45408      33.16        100

. sum govt_legseatshare if presidential==0 & formateur==1;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
govt_legse~e |         15      79.298    12.89797      50.83        100

. sum govt_legseatshare if presidential==1 & formateur==1;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
govt_legse~e |         11    69.15455    25.45501      33.16      97.17

. ttest govt_legseatshare if formateur==1, by(presidential) unequal;

Two-sample t test with unequal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
       0 |      15      79.298    3.330241    12.89797    72.15534    86.44066
       1 |      11    69.15455    7.674973    25.45501    52.05364    86.25545
---------+--------------------------------------------------------------------
combined |      26    75.00654     3.81526    19.45408    67.14886    82.86421
---------+--------------------------------------------------------------------
    diff |            10.14345    8.366345               -7.828563    28.11547
------------------------------------------------------------------------------
    diff = mean(0) - mean(1)                                      t =   1.2124
Ho: diff = 0                     Satterthwaite's degrees of freedom =  13.7713

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.8771         Pr(|T| > |t|) = 0.2457          Pr(T > t) = 0.1229

. *     ****************************************************************  *;
. *      Get some descriptive statistics about majority and minority      *;
. *      governments for govts in analyses (w/ partisan formateurs)       *;
. *     ****************************************************************  *;
. sum govt_legseatshare if govt_legseatshare<50 & formateur==1;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
govt_legse~e |          3    37.87667    5.692665      33.16       44.2

. sum govt_legseatshare if govt_legseatshare>=50 & formateur==1;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
govt_legse~e |         23    79.84957     14.6495       50.5        100

. list countryname year presidential govt_legseatshare if govt_legseatshare<50 & formateur==1;

     +---------------------------------------+
     | count~me   year   presid~l   govt_l~e |
     |---------------------------------------|
  9. |    Kenya   2008          1       44.2 |
 13. |   Malawi   2004          1      36.27 |
 15. |   Malawi   2014          1      33.16 |
     +---------------------------------------+

. save "C:\Users\sgolder\Dropbox\Portfolio Allocation\replication\Africa_govt_descriptive2.dta", replace;
file C:\Users\sgolder\Dropbox\Portfolio Allocation\replication\Africa_govt_descriptive2.dta saved

. log close;
      name:  <unnamed>
       log:  C:\Users\sgolder\Dropbox\Portfolio Allocation\replication\ariottigolder-descriptive2.log
  log type:  text
 closed on:  30 Mar 2017, 14:08:57
------------------------------------------------------------------------------------------------------------------
